package com.binguo.model.mapper;

import com.binguo.model.api.vo.SMStatisticsOrderVO;
import com.binguo.model.core.Mapper;
import com.binguo.model.model.YpCard;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface YpCardMapper extends Mapper<YpCard> {

    List<YpCard> getYpCardList(@Param("shopId") Integer shopId,
                               @Param("start") Integer start,
                               @Param("limit") Integer limit);

    Integer getYpCardCount(@Param("shopId") Integer shopId);

    @Select("select card_no from yp_card where card_menjin_id = #{cardMenjinId}")
    String getCardNoByCardMenjinId(@Param("cardMenjinId")String cardMenjinId);

}